Profiling Report

Dataset statistics

Number of variables	25
Number of observations	1296675
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	178.1 MiB
Average record size in memory	144.0 B

Variable types

Numeric	21
Categorical	4

Alerts

`amt` is highly overall correlated with `amt_day_interaction` and 2 other fields	High correlation
`amt_day_interaction` is highly overall correlated with `amt` and 2 other fields	High correlation
`amt_merchant_interaction` is highly overall correlated with `amt` and 2 other fields	High correlation
`amt_ratio` is highly overall correlated with `amt` and 2 other fields	High correlation
`day` is highly overall correlated with `day_of_month`	High correlation
`day_of_month` is highly overall correlated with `day`	High correlation
`day_of_week` is highly overall correlated with `amt_day_interaction` and 1 other fields	High correlation
`is_weekend` is highly overall correlated with `day_of_week`	High correlation
`merchant_encoded` is highly overall correlated with `amt_merchant_interaction`	High correlation
`is_fraud` is highly imbalanced (94.9%)	Imbalance
`high_value` is highly imbalanced (71.4%)	Imbalance
`amt` is highly skewed (γ1 = 42.27787379)	Skewed
`amt_ratio` is highly skewed (γ1 = 34.80955403)	Skewed
`amt_merchant_interaction` is highly skewed (γ1 = 50.34670773)	Skewed
`amt_day_interaction` is highly skewed (γ1 = 62.28714456)	Skewed
`day_of_week` has 254282 (19.6%) zeros	Zeros
`amt_day_interaction` has 254282 (19.6%) zeros	Zeros

Reproduction

Analysis started	2024-09-15 09:50:41.454016
Analysis finished	2024-09-15 09:54:01.779859
Duration	3 minutes and 20.33 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

amt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	52928
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.351035

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.65
median	47.52
Q3	83.14
95-th percentile	196.31
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.49

Descriptive statistics

Standard deviation	160.31604
Coefficient of variation (CV)	2.2788014
Kurtosis	4545.645
Mean	70.351035
Median Absolute Deviation (MAD)	37.5
Skewness	42.277874
Sum	91222429
Variance	25701.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	542	< 0.1%
1.04	538	< 0.1%
1.25	535	< 0.1%
1.02	533	< 0.1%
1.01	523	< 0.1%
1.05	519	< 0.1%
1.2	516	< 0.1%
1.23	515	< 0.1%
1.08	512	< 0.1%
1.11	509	< 0.1%
Other values (52918)	1291433	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	222	< 0.1%
1.01	523	< 0.1%
1.02	533	< 0.1%
1.03	499	< 0.1%
1.04	538	< 0.1%
1.05	519	< 0.1%
1.06	471	< 0.1%
1.07	498	< 0.1%
1.08	512	< 0.1%
1.09	496	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
17897.24	1	< 0.1%
15305.95	1	< 0.1%
15047.03	1	< 0.1%
15034.18	1	< 0.1%
14849.74	1	< 0.1%

first
Real number (ℝ)

Distinct	352
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180.26237

Minimum	0
Maximum	351
Zeros	4571
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	14
Q1	94
median	183
Q3	257
95-th percentile	329
Maximum	351
Range	351
Interquartile range (IQR)	163

Descriptive statistics

Standard deviation	97.533793
Coefficient of variation (CV)	0.54106574
Kurtosis	-1.0294248
Mean	180.26237
Median Absolute Deviation (MAD)	80
Skewness	-0.14559279
Sum	2.3374171 × 10⁸
Variance	9512.8408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	26669	2.1%
281	21667	1.7%
166	20581	1.6%
152	20039	1.5%
243	20009	1.5%
93	19965	1.5%
162	16940	1.3%
348	16371	1.3%
231	16346	1.3%
174	16325	1.3%
Other values (342)	1101763	85.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4571	0.4%
1	9844	0.8%
2	1027	0.1%
3	4582	0.4%
4	525	< 0.1%
5	1056	0.1%
6	6123	0.5%
7	2049	0.2%
8	5630	0.4%
9	1540	0.1%

Value	Count	Frequency (%)
351	2018	0.2%
350	1516	0.1%
349	1038	0.1%
348	16371	1.3%
347	1466	0.1%
346	533	< 0.1%
345	3059	0.2%
344	538	< 0.1%
343	529	< 0.1%
342	6695	0.5%

last
Real number (ℝ)

Distinct	481
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250.52092

Minimum	0
Maximum	480
Zeros	517
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	28
Q1	138
median	252
Q3	370
95-th percentile	463
Maximum	480
Range	480
Interquartile range (IQR)	232

Descriptive statistics

Standard deviation	136.67406
Coefficient of variation (CV)	0.54555946
Kurtosis	-1.1380827
Mean	250.52092
Median Absolute Deviation (MAD)	116
Skewness	-0.064789705
Sum	3.2484422 × 10⁸
Variance	18679.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
404	28794	2.2%
467	23605	1.8%
99	21910	1.7%
217	20034	1.5%
370	17394	1.3%
260	14805	1.1%
219	13976	1.1%
245	12753	1.0%
161	11799	0.9%
288	11698	0.9%
Other values (471)	1119907	86.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	517	< 0.1%
1	1565	0.1%
2	518	< 0.1%
3	1553	0.1%
4	501	< 0.1%
5	8185	0.6%
6	485	< 0.1%
7	8210	0.6%
8	1548	0.1%
9	504	< 0.1%

Value	Count	Frequency (%)
480	502	< 0.1%
479	3585	0.3%
478	3071	0.2%
477	3635	0.3%
476	2578	0.2%
475	4051	0.3%
474	1521	0.1%
473	4656	0.4%
472	2049	0.2%
471	1029	0.1%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	709863
1	586812

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring characters

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

street
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	488.03441

Minimum	0
Maximum	982
Zeros	2602
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	48
Q1	252
median	485
Q3	720
95-th percentile	929
Maximum	982
Range	982
Interquartile range (IQR)	468

Descriptive statistics

Standard deviation	280.06084
Coefficient of variation (CV)	0.57385469
Kurtosis	-1.1723021
Mean	488.03441
Median Absolute Deviation (MAD)	235
Skewness	0.0082662276
Sum	6.3282202 × 10⁸
Variance	78434.073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	3123	0.2%
859	3123	0.2%
814	3119	0.2%
472	3117	0.2%
805	3113	0.2%
303	3112	0.2%
160	3110	0.2%
848	3107	0.2%
417	3106	0.2%
601	3101	0.2%
Other values (973)	1265544	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2602	0.2%
1	1523	0.1%
2	972	0.1%
3	11	< 0.1%
4	1019	0.1%
5	1542	0.1%
6	3123	0.2%
7	524	< 0.1%
8	2032	0.2%
9	2036	0.2%

Value	Count	Frequency (%)
982	1035	0.1%
981	1022	0.1%
980	521	< 0.1%
979	504	< 0.1%
978	8	< 0.1%
977	2553	0.2%
976	1518	0.1%
975	2021	0.2%
974	998	0.1%
973	523	< 0.1%

city
Real number (ℝ)

Distinct	894
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	445.26328

Minimum	0
Maximum	893
Zeros	532
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	46
Q1	224
median	439
Q3	677
95-th percentile	843
Maximum	893
Range	893
Interquartile range (IQR)	453

Descriptive statistics

Standard deviation	258.60012
Coefficient of variation (CV)	0.58078024
Kurtosis	-1.2142164
Mean	445.26328
Median Absolute Deviation (MAD)	225
Skewness	0.0094241413
Sum	5.7736177 × 10⁸
Variance	66874.021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	5617	0.4%
725	5130	0.4%
821	5105	0.4%
644	5075	0.4%
501	5060	0.4%
796	4634	0.4%
171	4613	0.4%
154	4604	0.4%
837	4599	0.4%
359	4168	0.3%
Other values (884)	1248070	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	532	< 0.1%
1	2097	0.2%
2	516	< 0.1%
3	2035	0.2%
4	511	< 0.1%
5	1056	0.1%
6	1025	0.1%
7	1019	0.1%
8	1034	0.1%
9	1049	0.1%

Value	Count	Frequency (%)
893	1537	0.1%
892	1557	0.1%
891	525	< 0.1%
890	2109	0.2%
889	514	< 0.1%
888	511	< 0.1%
887	537	< 0.1%
886	1055	0.1%
885	1040	0.1%
884	11	< 0.1%

state
Real number (ℝ)

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.677282

Minimum	0
Maximum	50
Zeros	2120
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	15
median	28
Q3	38
95-th percentile	48
Maximum	50
Range	50
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.330978
Coefficient of variation (CV)	0.53719783
Kurtosis	-1.123464
Mean	26.677282
Median Absolute Deviation (MAD)	12
Skewness	-0.21677598
Sum	34591765
Variance	205.37694
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43	94876	7.3%
34	83501	6.4%
38	79847	6.2%
4	56360	4.3%
35	46480	3.6%
22	46154	3.6%
14	43252	3.3%
9	42671	3.3%
1	40989	3.2%
24	38403	3.0%
Other values (41)	724142	55.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2120	0.2%
1	40989	3.2%
2	31127	2.4%
3	10770	0.8%
4	56360	4.3%
5	13880	1.1%
6	7702	0.6%
7	3613	0.3%
8	9	< 0.1%
9	42671	3.3%

Value	Count	Frequency (%)
50	19322	1.5%
49	25691	2.0%
48	29368	2.3%
47	18924	1.5%
46	11768	0.9%
45	29250	2.3%
44	10699	0.8%
43	94876	7.3%
42	17554	1.4%
41	12324	1.0%

job
Real number (ℝ)

Distinct	494
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	251.17343

Minimum	0
Maximum	493
Zeros	1041
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	131
median	251
Q3	374
95-th percentile	469
Maximum	493
Range	493
Interquartile range (IQR)	243

Descriptive statistics

Standard deviation	140.10937
Coefficient of variation (CV)	0.55781922
Kurtosis	-1.1957791
Mean	251.17343
Median Absolute Deviation (MAD)	122
Skewness	-0.014278309
Sum	3.2569031 × 10⁸
Variance	19630.635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
193	9779	0.8%
187	9199	0.7%
308	8684	0.7%
439	8680	0.7%
286	8270	0.6%
121	8225	0.6%
444	7700	0.6%
239	7679	0.6%
194	7659	0.6%
178	7547	0.6%
Other values (484)	1213253	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1041	0.1%
1	11	< 0.1%
2	534	< 0.1%
3	2580	0.2%
4	4673	0.4%
5	1577	0.1%
6	3604	0.3%
7	535	< 0.1%
8	2524	0.2%
9	2571	0.2%

Value	Count	Frequency (%)
493	504	< 0.1%
492	2601	0.2%
491	2556	0.2%
490	510	< 0.1%
489	6164	0.5%
488	2538	0.2%
487	7	< 0.1%
486	3049	0.2%
485	2024	0.2%
484	998	0.1%

unix_time
Real number (ℝ)

Distinct	1274823
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3492436 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3718168 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.328672 × 10⁹
Q1	1.3387507 × 10⁹
median	1.3492497 × 10⁹
Q3	1.3593854 × 10⁹
95-th percentile	1.3698306 × 10⁹
Maximum	1.3718168 × 10⁹
Range	46440799
Interquartile range (IQR)	20634633

Descriptive statistics

Standard deviation	12841278
Coefficient of variation (CV)	0.0095173904
Kurtosis	-1.0875405
Mean	1.3492436 × 10⁹
Median Absolute Deviation (MAD)	10358807
Skewness	0.0033779498
Sum	1.7495305 × 10¹⁵
Variance	1.6489843 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1370177227	4	< 0.1%
1335110521	4	< 0.1%
1370050667	4	< 0.1%
1367602155	3	< 0.1%
1364686521	3	< 0.1%
1369587838	3	< 0.1%
1337306743	3	< 0.1%
1343668520	3	< 0.1%
1341944714	3	< 0.1%
1340650327	3	< 0.1%
Other values (1274813)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1371816817	1	< 0.1%
1371816816	1	< 0.1%
1371816752	1	< 0.1%
1371816739	1	< 0.1%
1371816728	1	< 0.1%
1371816696	1	< 0.1%
1371816683	1	< 0.1%
1371816656	1	< 0.1%
1371816562	1	< 0.1%
1371816522	1	< 0.1%

merch_lat
Real number (ℝ)

Distinct	1247805
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537338

Minimum	19.027785
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	19.027785
5-th percentile	29.751653
Q1	34.733572
median	39.36568
Q3	41.957164
95-th percentile	46.00353
Maximum	67.510267
Range	48.482482
Interquartile range (IQR)	7.223592

Descriptive statistics

Standard deviation	5.1097884
Coefficient of variation (CV)	0.13259318
Kurtosis	0.79599391
Mean	38.537338
Median Absolute Deviation (MAD)	3.397536
Skewness	-0.18191543
Sum	49970403
Variance	26.109937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.305966	4	< 0.1%
41.937796	4	< 0.1%
42.265012	4	< 0.1%
41.301611	4	< 0.1%
34.134994	4	< 0.1%
37.669788	4	< 0.1%
39.348185	4	< 0.1%
32.64469	4	< 0.1%
42.749184	4	< 0.1%
38.050673	4	< 0.1%
Other values (1247795)	1296635	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%
19.034687	1	< 0.1%
19.035472	1	< 0.1%
19.036312	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.67355	1	< 0.1%
66.664673	1	< 0.1%
66.659242	1	< 0.1%

merch_long
Real number (ℝ)

Distinct	1275745
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226465

Minimum	-166.67124
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-166.67124
5-th percentile	-119.33009
Q1	-96.897276
median	-87.438392
Q3	-80.236796
95-th percentile	-73.354218
Maximum	-66.950902
Range	99.72034
Interquartile range (IQR)	16.660479

Descriptive statistics

Standard deviation	13.771091
Coefficient of variation (CV)	-0.15262806
Kurtosis	1.8484792
Mean	-90.226465
Median Absolute Deviation (MAD)	8.227889
Skewness	-1.1469599
Sum	-1.169944 × 10⁸
Variance	189.64294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.116414	4	< 0.1%
-81.219189	4	< 0.1%
-74.618269	4	< 0.1%
-85.326323	3	< 0.1%
-84.890305	3	< 0.1%
-88.49309	3	< 0.1%
-84.100102	3	< 0.1%
-97.527227	3	< 0.1%
-85.3444	3	< 0.1%
-86.037494	3	< 0.1%
Other values (1275735)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-166.671242	1	< 0.1%
-166.670132	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%
-166.662888	1	< 0.1%
-166.661968	1	< 0.1%
-166.659277	1	< 0.1%
-166.657834	1	< 0.1%
-166.657174	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%
-66.961923	1	< 0.1%
-66.962913	1	< 0.1%
-66.963918	1	< 0.1%
-66.963975	1	< 0.1%

is_fraud
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	1289169
1	7506

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

day
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.587978

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8291214
Coefficient of variation (CV)	0.5664058
Kurtosis	-1.1871417
Mean	15.587978
Median Absolute Deviation (MAD)	8
Skewness	0.030847364
Sum	20212542
Variance	77.953384
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	47089	3.6%
15	46213	3.6%
8	46201	3.6%
16	44894	3.5%
2	44748	3.5%
9	44685	3.4%
7	44239	3.4%
14	44015	3.4%
28	43470	3.4%
17	42272	3.3%
Other values (21)	848849	65.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	47089	3.6%
2	44748	3.5%
3	41842	3.2%
4	41479	3.2%
5	41886	3.2%
6	41420	3.2%
7	44239	3.4%
8	46201	3.6%
9	44685	3.4%
10	41934	3.2%

Value	Count	Frequency (%)
31	24701	1.9%
30	41019	3.2%
29	39617	3.1%
28	43470	3.4%
27	39684	3.1%
26	40692	3.1%
25	40374	3.1%
24	41360	3.2%
23	40815	3.1%
22	42061	3.2%

day_of_week
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0706037

Minimum	0
Maximum	6
Zeros	254282
Zeros (%)	19.6%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.1981526
Coefficient of variation (CV)	0.71586984
Kurtosis	-1.445049
Mean	3.0706037
Median Absolute Deviation (MAD)	2
Skewness	-0.078453041
Sum	3981575
Variance	4.8318747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	254282	19.6%
6	250579	19.3%
5	200957	15.5%
1	160227	12.4%
4	152272	11.7%
3	147285	11.4%
2	131073	10.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	254282	19.6%
1	160227	12.4%
2	131073	10.1%
3	147285	11.4%
4	152272	11.7%
5	200957	15.5%
6	250579	19.3%

Value	Count	Frequency (%)
6	250579	19.3%
5	200957	15.5%
4	152272	11.7%
3	147285	11.4%
2	131073	10.1%
1	160227	12.4%
0	254282	19.6%

age
Real number (ℝ)

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.742545

Minimum	15
Maximum	96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	15
5-th percentile	23
Q1	33
median	45
Q3	58
95-th percentile	81
Maximum	96
Range	81
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	17.378485
Coefficient of variation (CV)	0.37179158
Kurtosis	-0.1763463
Mean	46.742545
Median Absolute Deviation (MAD)	12
Skewness	0.61235845
Sum	60609890
Variance	302.01173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	45483	3.5%
36	40038	3.1%
33	37481	2.9%
35	37313	2.9%
46	34299	2.6%
44	32706	2.5%
34	31851	2.5%
30	31386	2.4%
47	31271	2.4%
32	30718	2.4%
Other values (71)	944129	72.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15	1959	0.2%
16	7496	0.6%
17	3975	0.3%
19	5603	0.4%
20	9530	0.7%
21	18827	1.5%
22	13241	1.0%
23	29689	2.3%
24	6008	0.5%
25	20573	1.6%

Value	Count	Frequency (%)
96	536	< 0.1%
95	11	< 0.1%
94	6063	0.5%
93	4645	0.4%
92	4131	0.3%
91	6224	0.5%
90	3605	0.3%
89	4610	0.4%
88	2096	0.2%
87	3041	0.2%

merchant_encoded
Real number (ℝ)

HIGH CORRELATION

Distinct	693
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	342.85849

Minimum	0
Maximum	692
Zeros	1844
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	33
Q1	165
median	346
Q3	514
95-th percentile	659
Maximum	692
Range	692
Interquartile range (IQR)	349

Descriptive statistics

Standard deviation	200.9519
Coefficient of variation (CV)	0.58610739
Kurtosis	-1.215053
Mean	342.85849
Median Absolute Deviation (MAD)	175
Skewness	0.0086598641
Sum	4.4457604 × 10⁸
Variance	40381.666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
316	4403	0.3%
105	3649	0.3%
571	3634	0.3%
349	3510	0.3%
70	3493	0.3%
136	3434	0.3%
117	2736	0.2%
358	2734	0.2%
463	2723	0.2%
607	2721	0.2%
Other values (683)	1263638	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1844	0.1%
1	1763	0.1%
2	1751	0.1%
3	1895	0.1%
4	940	0.1%
5	1746	0.1%
6	1904	0.1%
7	2503	0.2%
8	1923	0.1%
9	821	0.1%

Value	Count	Frequency (%)
692	1783	0.1%
691	2560	0.2%
690	1695	0.1%
689	1804	0.1%
688	1297	0.1%
687	2017	0.2%
686	1870	0.1%
685	1766	0.1%
684	1872	0.1%
683	2358	0.2%

time_diff
Real number (ℝ)

Distinct	158975
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32460.389

Minimum	0
Maximum	1341471
Zeros	1003
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	0
5-th percentile	969
Q1	6004
median	16563
Q3	40239
95-th percentile	113905
Maximum	1341471
Range	1341471
Interquartile range (IQR)	34235

Descriptive statistics

Standard deviation	47331.145
Coefficient of variation (CV)	1.4581201
Kurtosis	31.873749
Mean	32460.389
Median Absolute Deviation (MAD)	12924
Skewness	4.2732438
Sum	4.2090574 × 10¹⁰
Variance	2.2402373 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1003	0.1%
221	91	< 0.1%
290	90	< 0.1%
118	90	< 0.1%
445	89	< 0.1%
572	88	< 0.1%
821	87	< 0.1%
11	87	< 0.1%
136	86	< 0.1%
379	86	< 0.1%
Other values (158965)	1294878	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1003	0.1%
1	62	< 0.1%
2	81	< 0.1%
3	76	< 0.1%
4	57	< 0.1%
5	67	< 0.1%
6	67	< 0.1%
7	64	< 0.1%
8	72	< 0.1%
9	72	< 0.1%

Value	Count	Frequency (%)
1341471	1	< 0.1%
1205687	1	< 0.1%
1107569	1	< 0.1%
1096094	1	< 0.1%
1060731	1	< 0.1%
1053269	1	< 0.1%
1045690	1	< 0.1%
1039152	1	< 0.1%
1032247	1	< 0.1%
1016241	1	< 0.1%

day_of_month
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.589412

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8312176
Coefficient of variation (CV)	0.56648818
Kurtosis	-1.1868502
Mean	15.589412
Median Absolute Deviation (MAD)	8
Skewness	0.031380011
Sum	20214401
Variance	77.990405
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	47089	3.6%
15	46213	3.6%
8	46201	3.6%
16	44894	3.5%
2	44748	3.5%
9	44685	3.4%
7	44239	3.4%
14	44015	3.4%
17	42272	3.3%
22	42061	3.2%
Other values (21)	850258	65.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	47089	3.6%
2	44748	3.5%
3	41842	3.2%
4	41479	3.2%
5	41886	3.2%
6	41420	3.2%
7	44239	3.4%
8	46201	3.6%
9	44685	3.4%
10	41934	3.2%

Value	Count	Frequency (%)
31	24701	1.9%
30	41019	3.2%
29	41476	3.2%
28	41611	3.2%
27	39684	3.1%
26	40692	3.1%
25	40374	3.1%
24	41360	3.2%
23	40815	3.1%
22	42061	3.2%

is_weekend
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	845139
1	451536

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

Most occurring characters

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	845139	65.2%
1	451536	34.8%

amt_ratio
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1166530
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1

Minimum	0.0086933687
Maximum	386.48159
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	0.0086933687
5-th percentile	0.037613054
Q1	0.15441537
median	0.66941509
Q3	1.187412
95-th percentile	2.620873
Maximum	386.48159
Range	386.47289
Interquartile range (IQR)	1.0329966

Descriptive statistics

Standard deviation	2.2999175
Coefficient of variation (CV)	2.2999175
Kurtosis	2845.425
Mean	1
Median Absolute Deviation (MAD)	0.51563683
Skewness	34.809554
Sum	1296675
Variance	5.2896205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1697644044	9	< 0.1%
0.1066987452	9	< 0.1%
0.08787319111	8	< 0.1%
0.0790465957	8	< 0.1%
0.1549432174	8	< 0.1%
0.04983253947	7	< 0.1%
0.08567179375	7	< 0.1%
0.05196871342	7	< 0.1%
0.07718171096	7	< 0.1%
0.02356862305	7	< 0.1%
Other values (1166520)	1296598	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.008693368698	1	< 0.1%
0.00877907162	1	< 0.1%
0.00929940348	1	< 0.1%
0.009387522129	1	< 0.1%
0.009534706331	1	< 0.1%
0.009548024185	2	< 0.1%
0.009568974574	1	< 0.1%
0.009641632266	1	< 0.1%
0.009828848426	1	< 0.1%
0.009856043811	1	< 0.1%

Value	Count	Frequency (%)
386.4815883	1	< 0.1%
358.5962394	1	< 0.1%
283.0207865	1	< 0.1%
248.4744115	1	< 0.1%
236.1516822	1	< 0.1%
235.729112	1	< 0.1%
235.4992914	1	< 0.1%
233.4279738	1	< 0.1%
219.4420112	1	< 0.1%
217.5342348	1	< 0.1%

high_value
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	1231853
1	64822

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

Most occurring characters

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1231853	95.0%
1	64822	5.0%

amt_merchant_interaction
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	850172
Distinct (%)	65.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24035.621

Minimum	0
Maximum	15748202
Zeros	1844
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	0
5-th percentile	382.3
Q1	2552.1
median	10352.25
Q3	29331.085
95-th percentile	77275.25
Maximum	15748202
Range	15748202
Interquartile range (IQR)	26778.985

Descriptive statistics

Standard deviation	64788.516
Coefficient of variation (CV)	2.6955208
Kurtosis	6863.1684
Mean	24035.621
Median Absolute Deviation (MAD)	9173.73
Skewness	50.346708
Sum	3.1166389 × 10¹⁰
Variance	4.1975518 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1844	0.1%
672	36	< 0.1%
1224	36	< 0.1%
756	35	< 0.1%
693	32	< 0.1%
1344	31	< 0.1%
1056	31	< 0.1%
1512	31	< 0.1%
1008	30	< 0.1%
315	30	< 0.1%
Other values (850162)	1294539	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1844	0.1%
1	1	< 0.1%
1.01	1	< 0.1%
1.03	1	< 0.1%
1.04	1	< 0.1%
1.05	2	< 0.1%
1.06	2	< 0.1%
1.1	1	< 0.1%
1.11	3	< 0.1%
1.13	1	< 0.1%

Value	Count	Frequency (%)
15748201.6	1	< 0.1%
11832531.84	1	< 0.1%
11715740.64	1	< 0.1%
11114186.04	1	< 0.1%
7866051.3	1	< 0.1%
7668280.95	1	< 0.1%
7448548.25	1	< 0.1%
7414617.32	1	< 0.1%
7126857.95	1	< 0.1%
6743415.28	1	< 0.1%

amt_day_interaction
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	99344
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	215.66738

Minimum	0
Maximum	173693.4
Zeros	254282
Zeros (%)	19.6%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8.25
median	73.29
Q3	269.75
95-th percentile	741.42
Maximum	173693.4
Range	173693.4
Interquartile range (IQR)	261.5

Descriptive statistics

Standard deviation	631.42542
Coefficient of variation (CV)	2.9277743
Kurtosis	10492.695
Mean	215.66738
Median Absolute Deviation (MAD)	73.29
Skewness	62.287145
Sum	2.796505 × 10⁸
Variance	398698.06
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	254282	19.6%
9	355	< 0.1%
7.5	334	< 0.1%
10.2	314	< 0.1%
12	313	< 0.1%
10.8	311	< 0.1%
6.24	301	< 0.1%
6	296	< 0.1%
9.48	291	< 0.1%
15	288	< 0.1%
Other values (99334)	1039590	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	254282	19.6%
1	36	< 0.1%
1.01	67	< 0.1%
1.02	62	< 0.1%
1.03	70	< 0.1%
1.04	53	< 0.1%
1.05	59	< 0.1%
1.06	60	< 0.1%
1.07	55	< 0.1%
1.08	65	< 0.1%

Value	Count	Frequency (%)
173693.4	1	< 0.1%
135598.85	1	< 0.1%
132720.6	1	< 0.1%
107383.44	1	< 0.1%
100347.76	1	< 0.1%
90282.18	1	< 0.1%
76725.06	1	< 0.1%
72338.2	1	< 0.1%
72036.25	1	< 0.1%
67684.2	1	< 0.1%

amt_mean
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.351035

Minimum	42.951671
Maximum	948.81818
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	42.951671
5-th percentile	52.795807
Q1	59.813649
median	65.09374
Q3	83.277582
95-th percentile	96.281225
Maximum	948.81818
Range	905.86651
Interquartile range (IQR)	23.463933

Descriptive statistics

Standard deviation	19.410291
Coefficient of variation (CV)	0.27590625
Kurtosis	459.14005
Mean	70.351035
Median Absolute Deviation (MAD)	7.1445792
Skewness	14.40415
Sum	91222429
Variance	376.75938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
61.45309958	3123	0.2%
55.35335575	3123	0.2%
89.77494389	3119	0.2%
57.5451941	3117	0.2%
48.47894957	3113	0.2%
52.44669344	3112	0.2%
95.31727653	3110	0.2%
52.78476344	3107	0.2%
91.44027688	3106	0.2%
89.6934118	3101	0.2%
Other values (973)	1265544	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42.951671	1538	0.1%
44.71734531	501	< 0.1%
46.88654145	1544	0.1%
46.93667091	1571	0.1%
46.98265945	2587	0.2%
47.17054602	2564	0.2%
47.18054799	3011	0.2%
47.94510046	2588	0.2%
48.47894957	3113	0.2%
48.48821547	2107	0.2%

Value	Count	Frequency (%)
948.8181818	11	< 0.1%
918.4255556	9	< 0.1%
874.5057143	7	< 0.1%
858.48	8	< 0.1%
842.23125	8	< 0.1%
833.969	10	< 0.1%
810.2785714	7	< 0.1%
799.2133333	9	< 0.1%
778.5718182	11	< 0.1%
774.74375	8	< 0.1%

amt_std
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141.34551

Minimum	60.247108
Maximum	1202.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	60.247108
5-th percentile	83.708636
Q1	103.59066
median	122.37808
Q3	149.71688
95-th percentile	266.56177
Maximum	1202.988
Range	1142.7409
Interquartile range (IQR)	46.126219

Descriptive statistics

Standard deviation	73.303097
Coefficient of variation (CV)	0.51860931
Kurtosis	46.700004
Mean	141.34551
Median Absolute Deviation (MAD)	21.853523
Skewness	5.0391525
Sum	1.8327919 × 10⁸
Variance	5373.344
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
143.1626102	3123	0.2%
121.6611149	3123	0.2%
118.4502102	3119	0.2%
211.4021978	3117	0.2%
131.566918	3113	0.2%
155.4128126	3112	0.2%
216.5906992	3110	0.2%
140.3830389	3107	0.2%
132.7622028	3106	0.2%
137.017678	3101	0.2%
Other values (973)	1265544	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60.24710813	504	< 0.1%
64.15872518	471	< 0.1%
65.34697836	518	< 0.1%
65.53295778	972	0.1%
65.84396856	496	< 0.1%
66.98899721	525	< 0.1%
67.49926144	1494	0.1%
70.82320784	1005	0.1%
71.420119	485	< 0.1%
72.37512206	509	< 0.1%

Value	Count	Frequency (%)
1202.988005	510	< 0.1%
1165.824421	520	< 0.1%
867.2878545	1017	0.1%
644.2690528	2050	0.2%
623.2522115	540	< 0.1%
543.2532612	13	< 0.1%
512.7832113	550	< 0.1%
510.8874515	2597	0.2%
483.3276455	1060	0.1%
482.145942	10	< 0.1%

Auto

Heatmap
Table

	age	amt	amt_day_interaction	amt_mean	amt_merchant_interaction	amt_ratio	amt_std	city	day	day_of_month	day_of_week	first	gender	high_value	is_fraud	is_weekend	job	last	merch_lat	merch_long	merchant_encoded	state	street	time_diff	unix_time
age	1.000	-0.024	-0.022	0.009	-0.025	-0.006	-0.058	-0.012	0.001	0.001	-0.013	-0.003	0.132	0.043	0.020	0.046	-0.026	0.017	0.036	-0.020	-0.007	-0.057	0.049	0.125	-0.004
amt	-0.024	1.000	0.579	0.227	0.811	0.979	-0.086	-0.002	0.000	0.000	-0.001	-0.002	0.000	0.074	0.000	0.001	-0.010	-0.008	0.012	0.000	-0.012	0.010	0.008	0.030	0.001
amt_day_interaction	-0.022	0.579	1.000	0.131	0.479	0.570	-0.051	-0.003	0.018	0.018	0.684	-0.002	0.001	0.046	0.000	0.008	-0.005	-0.004	0.008	0.001	-0.006	0.007	0.005	0.062	-0.018
amt_mean	0.009	0.227	0.131	1.000	0.188	0.057	0.054	0.004	-0.000	-0.000	-0.003	-0.039	0.010	0.085	0.313	0.005	-0.010	-0.052	-0.025	0.007	0.004	-0.000	0.003	0.064	0.002
amt_merchant_interaction	-0.025	0.811	0.479	0.188	1.000	0.798	-0.069	-0.001	0.000	0.000	-0.000	-0.003	0.000	0.053	0.000	0.000	-0.008	-0.007	0.009	-0.001	0.500	0.008	0.006	0.026	-0.000
amt_ratio	-0.006	0.979	0.570	0.057	0.798	1.000	-0.076	-0.000	0.000	0.000	0.000	0.003	0.000	0.086	0.000	0.001	-0.007	-0.000	0.011	-0.001	-0.013	0.004	0.005	0.025	0.000
amt_std	-0.058	-0.086	-0.051	0.054	-0.069	-0.076	1.000	-0.027	0.001	0.001	-0.002	-0.051	0.112	0.008	0.044	0.003	0.072	-0.037	-0.069	0.037	0.002	0.019	-0.025	-0.040	-0.003
city	-0.012	-0.002	-0.003	0.004	-0.001	-0.000	-0.027	1.000	-0.000	-0.000	-0.001	-0.012	0.057	0.022	0.005	0.007	0.021	0.019	-0.041	-0.067	-0.000	-0.043	-0.023	-0.010	-0.000
day	0.001	0.000	0.018	-0.000	0.000	0.000	0.001	-0.000	1.000	1.000	0.017	0.000	0.000	0.002	0.009	0.070	-0.001	-0.000	-0.000	0.000	-0.001	-0.001	-0.001	-0.002	0.019
day_of_month	0.001	0.000	0.018	-0.000	0.000	0.000	0.001	-0.000	1.000	1.000	0.017	0.000	0.000	0.002	0.009	0.069	-0.001	-0.000	-0.000	0.000	-0.001	-0.001	-0.001	-0.002	0.019
day_of_week	-0.013	-0.001	0.684	-0.003	-0.000	0.000	-0.002	-0.001	0.017	0.017	1.000	-0.000	0.006	0.002	0.012	1.000	0.001	0.004	0.000	0.001	0.001	0.001	-0.003	-0.011	-0.029
first	-0.003	-0.002	-0.002	-0.039	-0.003	0.003	-0.051	-0.012	0.000	0.000	-0.000	1.000	0.200	0.024	0.006	0.005	-0.040	-0.058	0.108	-0.030	-0.002	0.041	-0.045	-0.013	0.001
gender	0.132	0.000	0.001	0.010	0.000	0.000	0.112	0.057	0.000	0.000	0.006	0.200	1.000	0.047	0.008	0.004	0.143	0.089	0.103	0.082	0.006	0.082	0.134	0.031	0.000
high_value	0.043	0.074	0.046	0.085	0.053	0.086	0.008	0.022	0.002	0.002	0.002	0.024	0.047	1.000	0.249	0.001	0.014	0.015	0.022	0.013	0.023	0.024	0.015	0.007	0.003
is_fraud	0.020	0.000	0.000	0.313	0.000	0.000	0.044	0.005	0.009	0.009	0.012	0.006	0.008	0.249	1.000	0.004	0.005	0.004	0.008	0.005	0.010	0.004	0.005	0.010	0.018
is_weekend	0.046	0.001	0.008	0.005	0.000	0.001	0.003	0.007	0.070	0.069	1.000	0.005	0.004	0.001	0.004	1.000	0.007	0.010	0.004	0.005	0.001	0.003	0.008	0.025	0.083
job	-0.026	-0.010	-0.005	-0.010	-0.008	-0.007	0.072	0.021	-0.001	-0.001	0.001	-0.040	0.143	0.014	0.005	0.007	1.000	-0.024	-0.013	-0.006	0.001	0.042	-0.021	-0.017	-0.000
last	0.017	-0.008	-0.004	-0.052	-0.007	-0.000	-0.037	0.019	-0.000	-0.000	0.004	-0.058	0.089	0.015	0.004	0.010	-0.024	1.000	-0.019	-0.039	-0.000	-0.051	0.004	-0.007	0.000
merch_lat	0.036	0.012	0.008	-0.025	0.009	0.011	-0.069	-0.041	-0.000	-0.000	0.000	0.108	0.103	0.022	0.008	0.004	-0.013	-0.019	1.000	0.104	-0.002	0.194	-0.005	0.012	0.001
merch_long	-0.020	0.000	0.001	0.007	-0.001	-0.001	0.037	-0.067	0.000	0.000	0.001	-0.030	0.082	0.013	0.005	0.005	-0.006	-0.039	0.104	1.000	-0.001	0.090	0.074	0.006	-0.001
merchant_encoded	-0.007	-0.012	-0.006	0.004	0.500	-0.013	0.002	-0.000	-0.001	-0.001	0.001	-0.002	0.006	0.023	0.010	0.001	0.001	-0.000	-0.002	-0.001	1.000	-0.000	0.001	-0.000	-0.001
state	-0.057	0.010	0.007	-0.000	0.008	0.004	0.019	-0.043	-0.001	-0.001	0.001	0.041	0.082	0.024	0.004	0.003	0.042	-0.051	0.194	0.090	-0.000	1.000	0.009	-0.012	0.001
street	0.049	0.008	0.005	0.003	0.006	0.005	-0.025	-0.023	-0.001	-0.001	-0.003	-0.045	0.134	0.015	0.005	0.008	-0.021	0.004	-0.005	0.074	0.001	0.009	1.000	0.003	-0.001
time_diff	0.125	0.030	0.062	0.064	0.026	0.025	-0.040	-0.010	-0.002	-0.002	-0.011	-0.013	0.031	0.007	0.010	0.025	-0.017	-0.007	0.012	0.006	-0.000	-0.012	0.003	1.000	-0.035
unix_time	-0.004	0.001	-0.018	0.002	-0.000	0.000	-0.003	-0.000	0.019	0.019	-0.029	0.001	0.000	0.003	0.018	0.083	-0.000	0.000	0.001	-0.001	-0.001	0.001	-0.001	-0.035	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	amt	first	last	gender	street	city	state	job	unix_time	merch_lat	merch_long	day	day_of_week	age	merchant_encoded	day_of_month	amt_ratio	high_value	amt_merchant_interaction	amt_day_interaction	amt_mean	amt_std
0	4.97	162	18	0	568	526	27	370	1325376018	36.011293	-82.048315	1	1	32	514	1	0.056869	0	2554.58	4.97	87.393215	126.596221
1	107.23	309	157	0	435	612	47	428	1325376044	49.159047	-118.186462	1	1	42	241	1	1.987606	0	25842.43	107.23	53.949320	118.337621
2	220.11	115	381	1	602	468	13	307	1325376051	43.150704	-112.154481	1	1	58	390	1	3.341580	1	85842.90	220.11	65.870040	101.585754
3	45.00	163	463	1	930	84	26	328	1325376076	47.034331	-112.561071	1	1	53	360	1	0.618330	0	16200.00	45.00	72.776673	148.593473
4	41.96	336	149	1	418	216	45	116	1325376186	38.674999	-78.632459	1	1	34	297	1	0.440858	0	12462.12	41.96	95.178091	89.133972
5	94.63	162	82	0	471	223	38	479	1325376248	40.653382	-76.152667	1	1	59	607	1	1.446905	0	57440.41	94.63	65.401685	110.658809
6	44.54	199	360	0	882	351	16	29	1325376282	37.162705	-100.153370	1	1	27	534	1	0.493300	0	23784.36	44.54	90.289835	129.427131
7	71.65	311	467	1	224	236	45	127	1325376308	38.948089	-78.540296	1	1	73	107	1	1.043926	0	7666.55	71.65	68.635163	113.994926
8	4.27	144	70	0	685	474	38	375	1325376318	40.351813	-79.958146	1	1	79	250	1	0.062252	0	1067.50	4.27	68.591883	117.228359
9	198.39	239	3	0	213	149	42	329	1325376361	37.179198	-87.485381	1	1	46	563	1	2.107354	1	111693.57	198.39	94.141775	133.033890

	amt	first	last	gender	street	city	state	job	unix_time	merch_lat	merch_long	day	day_of_week	age	merchant_encoded	time_diff	day_of_month	is_weekend	amt_ratio	amt_merchant_interaction	amt_day_interaction	amt_mean	amt_std
1296665	72.17	152	207	1	737	651	22	147	1371816522	44.938461	-83.996234	21	6	26	211	10659.0	21	1	0.762142	15227.87	433.02	94.693681	89.230833
1296666	7.30	11	245	0	635	638	14	374	1371816562	40.556811	-88.092339	21	6	16	274	6401.0	21	1	0.101691	2000.20	43.80	71.786086	72.979539
1296667	19.71	74	124	1	960	317	9	186	1371816656	27.465871	-81.511804	21	6	29	221	13811.0	21	1	0.289941	4355.91	118.26	67.979325	210.676579
1296668	100.85	225	94	0	744	268	25	196	1371816683	31.377697	-90.528450	21	6	36	424	5451.0	21	1	1.130780	42760.40	605.10	89.186195	124.338770
1296669	37.38	228	345	0	483	584	29	311	1371816696	41.728638	-99.039660	21	6	40	598	72413.0	21	1	0.614222	22353.24	224.28	60.857433	151.348005
1296670	15.56	121	332	1	154	330	44	215	1371816728	36.841266	-111.690765	21	6	59	499	16781.0	21	1	0.246272	7764.44	93.36	63.182274	98.227403
1296671	51.70	160	463	1	856	813	20	360	1371816739	38.906881	-78.246528	21	6	41	2	7962.0	21	1	0.511119	103.40	310.20	101.150621	115.992546
1296672	105.93	74	67	1	158	346	32	308	1371816752	33.619513	-105.130529	21	6	53	599	29074.0	21	1	1.623797	63452.07	635.58	65.235995	131.805092
1296673	74.90	179	304	1	433	471	41	485	1371816816	42.788940	-103.241160	21	6	40	509	91018.0	21	1	0.782215	38124.10	449.40	95.753691	91.370450
1296674	4.30	160	404	1	127	782	26	467	1371816817	46.565983	-114.186110	21	6	25	370	44250.0	21	1	0.062383	1591.00	25.80	68.929193	75.785422

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample